SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407556 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407556 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924978,947888,842860,626441,407210,122856,937256,966439,743856,382659,797325,105994,457392,881733,201949,908442,813802,1045128,297133,139318,396538,284130,762750,200441,407085,803941,719313,904830,155779,681693,163412,875010,5995,783638,198579,190179,1002874,207004,456774,142713,198355,644045,740363,768812,713438,850870,495397,38258,884930,997093,635884,426430,955956,53393,200602,233874,126959,375078,774459,380728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407556 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407556 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]