SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381813 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381813 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044465,325877,182588,1039924,1007902,40304,42299,470015,635137,420506,78539,154937,253398,857233,317307,837578,913914,988664,225327,969944,447656,150354,214688,270722,364732,901700,63634,632515,261678,207877,438279,866695,1044739,11316,578700,646257,501131,323265,871915,341386,249715,242882,315421,790988,132426,564426,720498,875893,209706,434249,796013,394595,164752,766867,920719,1031577,960271,891446,254094,94516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]