SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425818 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425818 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246809,26345,1045691,200775,787210,911972,945214,126263,5093,170883,929140,390599,611349,309361,516806,273996,793029,356728,676613,656356,351598,1040095,766240,567268,217521,11381,143182,34373,969876,738557,634924,956989,260152,937582,741633,310154,763351,1008340,210369,754380,881258,476882,861187,39929,953768,834181,1008138,148503,1018913,685005,432683,147650,433440,304101,274238,1041920,924420,363680,582956,670607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]