SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388230 LIMIT 1 [ RunTime:0.000685s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388230 [ RunTime:0.003411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436048,178612,91386,562203,18900,98469,831239,730188,1008715,1041693,859402,280219,124410,210669,1010137,918100,607016,61850,84826,35159,1035216,986782,369548,181992,255032,40710,1044790,634528,365594,246766,772260,773063,604312,433582,126488,368007,888592,254856,853190,153953,805933,145141,1016257,117654,637780,798432,951387,1002908,556364,241825,59636,661506,563403,895107,680817,263062,356011,309521,288904,70639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]