SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426413 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426413 [ RunTime:0.002719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469257,203302,157841,439312,255920,812861,848195,601184,174899,179593,504977,677623,868024,320370,135461,1046747,686940,344102,883680,259398,247943,992824,588657,637695,136947,265649,89784,707999,929948,18283,777659,47388,748994,533900,123144,696835,724669,474149,582168,828792,484275,523898,280261,906530,43606,427597,577008,626554,453987,206740,1002824,394343,771914,150445,576512,178751,973815,830084,947572,275819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]