SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 700423 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 700423 [ RunTime:0.002163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411530,953531,806411,1015803,793591,861357,414622,1002225,259833,218655,344770,1034088,376584,879151,852392,87665,762437,751913,98013,919650,12969,818751,834308,440293,534469,1013818,386613,221824,161924,481652,470365,24303,581944,809243,1002658,624230,265650,946139,248093,577053,579869,274701,356216,139721,365121,179951,743394,376458,229214,211504,601631,713854,219844,755353,104210,21975,521088,29690,910150,801405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 700423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 700423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]