SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192613 LIMIT 1 [ RunTime:0.000712s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192613 [ RunTime:0.002991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265011,792596,880126,489282,674510,277765,995017,561418,103485,854389,408601,64523,383351,599326,53475,399586,639978,195152,513144,792543,876529,21461,769508,942114,137748,429373,589621,126627,862192,794067,940363,898932,175042,410447,283994,663926,840675,1008283,436251,998144,809608,688633,708735,498074,28559,920249,715897,377220,408102,233648,112444,558150,581882,499628,1008555,712732,984154,570905,108391,87613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]