SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193804 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193804 [ RunTime:0.002568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60129,256356,660930,603794,4164,270652,712250,935265,393362,539744,644008,58255,1020208,925383,719860,745966,660765,71303,284523,597449,1007233,1013618,83375,382854,994590,596713,885000,669879,865326,994911,1031019,271249,241381,857371,168930,31321,12236,81779,579513,320413,79893,505615,989928,142319,220505,372530,557170,694444,484858,392505,322386,454510,753164,264118,643800,784897,475524,1023308,752913,991480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002532s ]