SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284568 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284568 [ RunTime:0.002361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388849,859490,203440,987719,440057,343052,884028,735276,791673,26829,969306,232735,913493,677222,898643,773927,150804,946493,55682,53075,250085,74710,514993,106182,1044307,374594,11630,670312,711348,723208,487865,435840,477447,757006,483181,517054,537589,745455,650201,293201,589955,125788,915453,247827,99723,797888,880310,82917,149221,303469,168788,644593,523082,498174,219546,449686,130579,970553,668768,91000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]