SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519069 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519069 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032044,698359,167183,939201,269889,42051,954305,54088,451448,497704,638238,312388,532401,173183,512158,441114,63762,984045,148049,1038317,478119,522512,1013294,44300,268126,839605,574828,460530,523516,837059,454236,468064,1040683,726896,842088,150057,797455,295214,790586,1010513,924487,946764,1006965,50537,977404,305714,257701,300970,407713,858448,380688,479497,233770,209008,978489,59334,266890,546244,380427,728429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]