SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036540 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036540 [ RunTime:0.004163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013819,932945,137400,479333,350043,2959,975873,899667,601199,406882,686796,105096,117379,950586,584542,444267,404088,446378,831814,325192,124707,592671,271678,473077,522915,827001,1009142,654330,633257,502660,539837,10105,176434,283422,849721,815724,991737,222366,91255,5340,299959,11309,749447,740109,135155,19803,13172,90666,924206,768273,1005392,780460,250124,1031619,132488,1005825,1034224,340509,184721,382775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003648s ]