SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442192 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442192 [ RunTime:0.003089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378399,280123,324975,362814,136646,881823,37420,696549,779013,961577,348433,981305,460472,944643,1019144,660223,834241,309866,753845,530705,501142,248222,766496,350686,639550,664994,490519,503544,154598,849221,538767,399901,82745,365486,422735,244668,129268,302885,486543,427523,852429,479964,748373,174339,1022588,441141,428182,1038845,267266,775904,396447,687311,904886,531991,407125,222610,896344,768367,323519,267508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]