SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003008s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 962515 LIMIT 1 [ RunTime:0.001107s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 962515 [ RunTime:0.004103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475427,190500,264300,361855,115361,489383,272195,700392,455832,561351,203399,172001,559833,442100,411111,764316,172800,969218,497158,19982,514742,597530,87769,120899,364068,1014642,989103,741974,918193,409159,588130,907044,937261,64337,863925,710314,220272,219904,10387,657952,432534,304353,555233,944198,304617,1001547,473290,75991,468601,696173,308796,791646,900124,1032430,198123,567378,783563,797545,998497,415595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 962515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 962515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]