SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017023 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017023 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481580,73995,920557,734011,290495,540416,612950,47901,1003303,340191,93380,45240,501260,373886,642967,124191,261602,203913,843227,1008969,276980,927091,940595,896563,104327,637789,981342,89242,701656,238393,838853,360758,918151,316065,497551,243724,476872,704043,498466,711581,311126,977662,226487,375873,445538,171886,800537,621275,397751,747508,921675,896313,289010,782738,788932,675336,416458,448893,592990,416432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]