SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499528 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499528 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518867,540559,820751,819841,31944,209214,1031822,343004,417560,64788,908978,637535,688599,216051,181472,321757,509724,1709,387390,866851,360106,178604,895308,701849,1009862,703834,387731,670498,241248,716347,844143,297503,921690,464830,348619,813800,130805,769404,222236,393877,522249,418123,751205,89911,344019,1005268,1043920,238163,969555,882883,941387,426447,407118,152396,780346,455355,905619,250889,639244,136164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]