SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414961 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414961 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165278,448428,953007,691882,814619,961517,253203,958599,30858,162753,998505,177848,458361,653085,692984,896984,83563,365377,395693,788880,498281,497272,393133,547673,114885,423478,934310,242721,732533,964424,100031,976258,822105,799663,14484,682552,858434,947040,787272,832662,785019,439671,988710,856653,498595,225517,745914,779788,669742,294959,385370,970145,346825,112607,415909,868498,825205,1038930,136835,651570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]