SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326027 LIMIT 1 [ RunTime:0.002617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326027 [ RunTime:0.005363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336714,827225,1019994,811083,505677,1001872,720373,997502,214901,1007238,764065,1014071,900014,363864,437887,10409,498612,226447,687057,15435,967518,813567,944847,96703,250659,804002,699738,557006,565671,37802,367605,64710,793195,592512,904491,112889,356461,641004,508760,230164,384978,642121,34385,621900,939543,834558,387779,291688,297484,485177,191712,546086,639412,260268,265807,642932,593253,7100,474620,610492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]