SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521563 LIMIT 1 [ RunTime:0.001248s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521563 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88143,386663,684425,355476,60200,443183,922322,467517,488535,872341,733185,1022745,18778,89574,60548,235586,709338,750710,751555,940393,869194,787001,355877,615813,121676,1013138,313552,702496,436333,695922,281185,721073,188017,561585,560194,301601,863343,695753,372458,776287,181276,22482,175780,947143,881891,798542,453307,952614,883219,339518,656199,519799,99274,785261,133969,120327,252840,81414,925868,743122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003650s ]