SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 259103 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 259103 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890447,85104,152768,887721,219062,487079,66217,351814,762216,147048,344059,651869,973761,744582,778706,779355,681917,498483,322842,283607,287035,32062,155911,402679,763766,382960,464209,532485,672952,149937,214488,398660,920793,363700,327028,149327,1005339,55134,815121,1014526,681894,840917,192323,818642,147175,701820,349213,396671,492713,770838,271051,188256,233326,181265,286800,435163,1036094,122765,698315,306671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 259103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 259103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]