SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560516 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560516 [ RunTime:0.005618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793660,648742,558362,380636,938378,871657,223540,1014475,806503,812796,885798,350222,254429,326540,474226,709614,813905,663478,697124,774149,149846,62821,1002860,511881,880522,983365,653987,131025,925516,601400,565721,823545,101136,661610,883421,710061,206611,715000,138043,763160,1044857,411013,906280,151345,844295,235635,243345,512456,876856,887291,464446,219995,811371,124320,746517,71806,954542,814032,635119,274038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000903s ]