SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44313 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44313 [ RunTime:0.008062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684649,1006065,348705,257103,585961,306502,517982,960066,64434,275725,498445,358600,236755,190487,895695,467063,742700,827347,977046,246045,665345,375521,182781,435620,195875,931807,48795,536050,927159,108404,857073,914670,686405,816515,813615,451151,514340,432437,345118,584478,562642,721414,725803,995296,1048622,641776,122277,263131,452347,856850,982523,536073,184424,556371,222979,768185,799894,367031,688977,715563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]