SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303004 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303004 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820933,398397,699571,177298,502906,588537,572401,534897,258921,896203,121899,67641,227516,333206,1040944,735792,580033,1046068,209936,510341,208271,10834,662949,647268,91009,385621,208830,929347,1013630,851964,966827,189745,461272,381493,614516,999475,980894,78409,115263,92496,905286,752341,138124,222495,921375,734170,791368,345472,489794,709875,1046213,261085,321653,891015,919071,512101,522899,646787,620697,542740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]