SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426152 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426152 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510742,660585,1033167,537622,189102,968885,835380,127892,77151,581317,911344,65418,185689,295094,84966,815540,335330,423597,25550,341377,451701,551551,1012602,403487,492562,232943,941091,997463,882782,551739,1046889,459985,162730,339732,11665,242110,115694,877976,399697,655572,640526,116293,318531,440625,321252,486325,846152,830792,457792,457288,818752,412364,663327,634588,242298,160434,37170,413152,232841,602169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]