SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457608 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457608 [ RunTime:0.002796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841190,830358,770752,500584,353168,525644,792231,712532,1035037,572508,589932,805394,357268,703668,607133,972369,114286,609519,520106,344796,804305,78035,883731,815910,638414,341052,833600,246781,54578,612125,816043,272129,700675,348456,148794,326162,309492,939195,379360,849028,52139,631006,714670,84712,806480,575660,394425,521904,719587,183603,751642,560766,746068,648290,133669,594317,840939,968264,971600,869291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]