SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801475 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801475 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964979,483541,209330,206084,253228,683846,512621,319782,402446,1023725,379437,24053,19682,312059,753190,574130,53001,75071,544579,235629,1012817,382767,496559,715511,338961,81522,631880,964921,874541,184507,322275,347098,742748,1001521,803877,664440,261848,213818,880327,554316,1000657,499201,740192,121073,616083,443975,350766,389960,968836,608692,1018714,656059,85443,584955,418284,631576,921257,414020,906937,413906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000864s ]