SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504550 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504550 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391427,796217,715577,848012,458172,544425,727988,227301,418849,73480,423033,993189,211531,833822,974129,251442,441188,1030177,102224,1028795,323394,673218,750410,62520,460985,787968,1029459,164813,88014,561470,500949,774692,1042465,114631,39700,196597,286038,812793,259834,72278,703395,865854,1035007,628352,293182,635932,948563,152475,425574,804417,127811,798345,379753,687701,230882,157390,378570,788227,67778,499947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]