SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265323 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265323 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162331,786894,316898,140683,487399,1018600,327185,454245,752337,980242,776940,939287,132146,339990,140250,661509,342729,615520,432168,1018791,442208,757037,518842,341837,459274,557016,413444,261860,243938,523654,26773,25337,289281,662760,1029715,563145,785357,605556,653533,808846,382228,166707,137067,937069,334872,612040,137477,648398,807869,251360,369977,917788,349432,492714,297739,557452,292587,437853,67302,736472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001089s ]