SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029355 LIMIT 1 [ RunTime:0.000800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029355 [ RunTime:0.005601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524564,649281,437295,281280,926907,65566,519249,720356,199181,881396,956986,509580,403773,61113,1006417,276917,972437,921102,246639,542427,180990,570713,72321,94968,233056,510209,294536,194842,92804,996986,387249,963678,327052,597856,872630,39347,788754,383203,72561,397677,1044757,802105,308064,975527,237359,140827,47792,398396,267518,238535,421039,245837,642828,642355,1004319,542905,265129,79309,70087,335598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029355 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029355 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]