SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329864 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329864 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346329,792370,738628,109941,201618,1000595,841526,134057,992313,845467,693018,658567,985060,499220,110395,4421,1033578,4450,889974,904804,425870,88766,990696,321297,61965,412911,828925,1044740,476430,860966,777594,700878,921969,351569,489290,539961,561,552178,404200,861632,130035,819715,95893,457301,404244,164204,88059,840307,900472,865176,488412,155190,957580,67722,422953,331075,1046559,904021,354023,668450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]