SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195214 LIMIT 1 [ RunTime:0.002322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195214 [ RunTime:0.005934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382176,374722,577967,905098,556351,193078,587817,808745,313489,407711,94343,65823,416599,289383,642215,572107,877860,749629,777174,988623,448471,267871,690360,607599,457530,283914,759245,276974,404394,745218,707624,562920,563780,427774,984621,520331,331142,88841,719934,857205,831788,340799,712540,1034112,509238,197929,503671,397387,859199,1019796,385285,726067,515534,305019,172388,991409,930894,993416,490207,721890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]