SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505247 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505247 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970580,111118,780847,600820,601596,326042,248990,159255,111991,988832,20622,380557,288463,400578,419023,119025,852764,356745,815315,921209,658564,816302,1032811,647033,19241,654185,465873,185861,733241,431314,406223,796410,688844,878357,281705,568467,842798,285179,493906,463691,926120,978857,556243,693358,941202,424043,648677,971558,87500,375792,991558,828478,798862,169954,600364,734817,721458,254717,126721,924379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]