SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570553 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570553 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281198,738028,22707,844665,708390,153796,289287,108774,318724,401296,17178,307129,560076,280927,11010,294591,539020,104164,709314,632958,503690,236567,1019940,3520,820381,200024,707784,555764,524143,629521,240176,731028,278729,163125,413879,166253,581747,85639,974355,781625,681954,457584,957218,219931,253934,348140,313229,896142,933307,707673,1013445,979404,409935,11133,309124,223891,427907,322572,550959,57266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]