SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451793 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451793 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510625,512387,779431,576914,35492,323965,108522,355765,216923,678428,140209,406989,77609,792316,162156,285288,614377,604782,47916,400000,933911,1005829,385287,439108,787750,29575,490247,164923,176246,1047921,115330,661109,705000,103542,594365,681730,603315,834127,180725,440422,1018393,922256,150496,804337,387028,589577,1010774,863008,512154,972653,184205,440376,538714,862072,975513,723671,388704,119358,185106,306779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]