SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991480 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991480 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149623,608611,597391,357678,457165,710903,1014123,917749,107743,53911,284038,748103,981089,907474,337323,57892,10831,892902,924183,1034232,474082,103898,312701,281053,50321,933399,171987,837836,138485,803333,1026737,887748,51449,395188,123571,237190,656532,910091,805006,977753,557745,668877,576323,803466,174086,474905,70836,292079,571862,684459,242013,1008821,254107,166915,519317,14186,627973,222375,647415,945695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]