SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592523 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592523 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188276,175430,309665,639698,1005370,363045,940173,110391,1022189,817177,610928,37529,867586,584076,184964,722246,514735,594303,425639,107603,782346,234708,956690,77012,304834,888843,313347,973571,785462,58913,990621,915635,17798,860547,118615,229162,935226,609948,367103,399378,494526,243711,634485,53102,832394,27806,908423,1047089,606359,1044960,71245,1005771,273595,575057,958975,652987,148456,938741,855861,352640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]