SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473512 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473512 [ RunTime:0.001427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96210,870812,981040,1010872,489630,576088,610681,284285,266464,241251,95665,475926,173051,811380,291145,13027,245240,185691,804700,643833,792417,288737,971929,731335,108153,518618,566799,86016,999176,197040,164336,404057,813149,257868,440776,88060,407167,661923,295782,124110,275708,751668,846603,94834,900275,719151,657864,592789,716653,76581,363049,846595,962249,745024,119253,860471,423846,909540,877331,38921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]