SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424203 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424203 [ RunTime:0.001352s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916829,378705,405167,812865,27531,334517,415167,234388,194214,1009721,158255,1021918,799530,719642,191827,663655,94626,138223,995846,913456,326288,160088,733535,216018,445163,637960,132534,762157,903026,586432,382546,493610,569222,968095,186975,920328,1002664,303127,38330,384788,80578,835160,111698,633355,631089,575605,58527,177038,643394,479940,900615,64216,615822,703275,316587,214846,715220,458033,134722,881585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001648s ]