SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401598 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401598 [ RunTime:0.001391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316422,248,339879,542379,651764,442932,505934,570219,977825,998619,547613,213947,974096,72645,86115,933480,146708,740464,813844,865553,898321,945018,908628,886626,664156,635209,250842,832357,771152,394159,1047327,711454,808352,717481,696388,378344,134429,385396,32045,613091,458742,428676,546056,650938,57282,586206,597540,1015750,650327,133068,514582,558216,559656,973122,249876,152441,708381,1010895,38987,167623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]