SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104042 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104042 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809696,818561,384718,137320,123982,983291,649951,542176,261281,932456,862383,1003400,753999,19439,967767,698434,841376,363851,548692,337809,778484,564389,347601,1019496,341860,788408,1015112,459162,802626,657296,174937,322952,274606,374544,816545,680291,841306,115042,949874,46615,999318,650105,157031,738679,423907,793527,415834,781576,860785,492362,779650,297362,778098,437263,279593,86549,426363,453741,352150,984493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104042 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104042 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]