SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031033 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031033 [ RunTime:0.003351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444436,936150,242700,785769,534489,889212,718149,669922,1030233,1011335,116270,1021898,203469,987082,609942,621485,916719,734537,942370,109799,330462,356934,943487,681027,290072,599913,85644,931771,1027010,709712,1000278,815045,737923,509087,929838,832090,452760,815053,817744,712794,416033,857849,891931,465795,960086,498832,435168,368539,56514,811026,6645,314142,719542,794403,711430,938840,981945,499607,86194,175020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]