SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042383 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042383 [ RunTime:0.004515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879021,972880,110462,1016285,646995,15858,803301,263010,549844,518973,896619,1021937,381946,490609,422721,785955,749468,152749,354798,186203,688243,106100,333534,193970,863347,6629,367938,610102,388861,93396,242132,175797,694855,595884,530944,763460,124063,726787,1045501,348813,125925,753309,893224,482141,1002232,326217,672257,646768,579364,433042,328941,32552,670928,704207,945988,435323,928615,1018918,35387,668386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]