SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463811 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463811 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100642,199382,886801,995324,258751,234005,76956,480545,57963,303042,54238,433938,683172,360957,80595,996151,681555,634826,198865,20928,379988,428420,962842,274734,159232,1047772,16221,516641,156432,571945,892468,769427,711544,963507,472559,94365,474676,277983,583283,943262,53427,468671,728723,869710,283638,847414,1036080,901988,221642,990912,517705,543714,705819,687540,390063,976216,116658,47728,546519,293427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001163s ]