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` = 570223 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570223 [ RunTime:0.007964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8653,729485,125675,449134,256731,989779,1017186,887802,743815,31561,133203,996919,609762,98667,522037,179642,458344,530949,333598,810172,896097,450599,24890,316182,659803,659002,152332,914049,969557,444426,859925,305920,93408,912450,313600,272208,128935,357915,15365,96858,510564,437795,1030117,638713,209926,724837,271877,5516,867292,728866,168434,214506,305274,86412,467731,588716,320142,686650,289085,505014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000768s ]