SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580080 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580080 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234750,360989,565755,416043,865127,23703,175782,366545,257253,398230,1043729,902839,513432,45432,765868,347970,775993,301750,604751,744333,616858,298268,191844,234394,861451,74080,798102,981133,906975,34665,219299,344304,164330,495124,948940,1002000,665387,183329,437127,994788,846774,420624,527161,973386,334305,822465,378286,128400,641693,121666,343309,767787,982967,310124,100423,278744,240388,169394,619923,86462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]