SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536083 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536083 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876243,790666,728127,611098,593348,109851,855682,866071,501636,378177,606545,471496,538727,388,586063,436273,515386,101214,46534,798180,543586,284166,431109,682537,40085,847188,758532,293216,6053,771504,14696,527296,145738,584737,703431,680548,310300,470369,488947,265693,1022314,530573,954872,384940,974350,311180,829383,52465,554953,239617,179052,474268,923550,935693,523291,580071,799003,1045999,121404,250252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]