SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002754s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402636 LIMIT 1 [ RunTime:0.001295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402636 [ RunTime:0.004485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969481,618931,515589,425501,440447,672603,277201,1024879,147526,453389,567275,621035,243750,230891,962915,617672,932674,481304,781825,1031424,201211,491248,382288,883665,511246,795391,159422,548211,783205,238950,937913,1000005,301361,456967,901965,1010701,64677,148523,535026,246158,640764,305468,70827,829280,747316,201594,327078,280883,1017891,491907,455160,782113,304884,992151,623991,468710,837364,784880,180644,795544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000915s ]