SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97160 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97160 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15102,406927,718954,425054,881425,458401,551152,75028,889248,173925,538166,813251,144653,825072,243833,780833,47003,665095,510768,978412,1020238,212214,250599,911799,432592,809954,208745,404282,781758,377820,983844,187161,981329,46393,533333,1006048,832205,205677,100613,570013,580696,802536,748708,308885,341594,837905,1023595,966696,59416,95448,975756,519331,992627,388531,509769,518162,631448,933952,14574,649759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]