SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 17180 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 17180 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025112,714262,579666,312329,739859,684737,896506,733157,771643,165694,534454,67616,576258,476739,480141,883483,601758,438753,143199,342145,101387,905227,961928,676019,938547,419121,678774,479385,956913,242865,776552,595214,282613,694495,249101,378927,1023990,601428,100759,909875,358897,496217,551139,804047,1018551,627915,543037,775403,65921,323543,371276,227141,183266,142603,966127,876373,567335,316902,851628,636547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 17180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 17180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001658s ]