SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531512 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531512 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598728,1044216,1011383,1029519,448785,327905,280849,1037795,122234,716371,690208,87984,975775,181702,72359,301910,610508,3825,967702,541769,969431,139876,127246,865147,66097,797749,555314,979400,194510,22081,628006,542507,904746,924952,241157,1000051,139112,711587,512362,342159,911284,542268,446509,783657,261825,477451,624452,289175,131184,270806,849121,78053,185850,362910,86375,220273,1007665,382560,62463,600992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]