SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400176 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400176 [ RunTime:0.003881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726040,284822,157106,466595,962450,538143,204943,426803,530426,241720,331598,964833,433386,972392,1042580,548675,39305,122586,428042,589212,332023,324946,33798,355451,493724,492628,1018543,937827,330668,999225,780236,94727,160860,112559,810130,334634,952080,284575,457571,446774,851476,756112,797270,652019,250786,140184,784550,336694,673840,561921,813564,59709,149281,1030411,526544,453812,168628,210704,875278,49520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]