SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381308 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381308 [ RunTime:0.003450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643365,711425,97790,243028,503765,792355,719814,965616,328492,536085,167253,52612,770890,953025,43681,110275,1003767,123662,518437,1031026,371840,293913,783265,955618,915019,143809,856453,1042912,825609,188700,288640,489650,552155,479960,965143,251397,501748,460374,535232,766968,377086,805166,170496,579020,1014406,173096,262479,898766,503560,740738,327893,465356,439373,1017564,453577,191704,692943,425022,387008,970896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001895s ]