SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596976 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596976 [ RunTime:0.002529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70240,766237,617731,875876,997181,602055,247205,805711,906907,772452,931918,541764,144660,680660,709828,881961,745333,913499,336303,781327,186513,380262,675107,440608,59266,1030136,241456,19667,506844,275943,765274,518604,72425,728003,572652,448011,1016012,577380,134076,387207,450074,320112,399484,167278,220506,739045,972091,183779,995608,641220,920455,42563,117119,888327,431129,427324,607177,472412,725475,877953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002634s ]