SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267654 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267654 [ RunTime:0.002847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383540,759063,365380,950635,641225,56708,1043943,516952,113430,354405,579969,779760,813573,624519,953893,475950,877742,477110,648261,339676,988261,21667,57305,155060,223664,183196,1019094,531836,658904,662117,334341,309569,223537,657316,27384,810171,132993,275986,34559,617843,232316,19158,914666,898704,31825,816634,462668,843333,337224,717483,29120,339249,910410,962588,1030239,141579,195478,323955,991451,540432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]