SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50821 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50821 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956941,1033978,786087,494791,614040,600602,867696,1035125,62720,465805,405176,671969,927963,892989,935421,645587,756041,390053,253224,1016310,1038539,174023,595004,745578,15765,820403,15233,946676,25263,281169,380780,417466,66787,792759,936300,426231,332144,552484,109586,140037,955093,107855,1010168,363207,412404,85522,263036,923799,680457,42806,963217,144056,552243,768733,191380,265868,171676,602823,158887,104457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]