SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43104 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43104 [ RunTime:0.002089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500089,737324,693990,410755,741466,149214,720084,373060,169716,436586,982311,585778,569902,548535,505224,519274,562959,107951,779698,427225,821974,227917,633118,66546,83785,194432,722758,500675,640436,784300,58890,427207,138719,615098,510646,950691,325608,575209,36383,128996,964139,543075,217443,788252,11317,261129,37291,216038,379186,91522,934380,315007,600563,741067,321779,748257,981547,802189,427867,784389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]